Welcome to python!

14、批量物料编号在mysql数据库查询

from sqlalchemy import create_engine, text

import pandas as pd

# 创建数据库连接

engine = create_engine('mysql+mysqlconnector://root:502@localhost:3306/shn')

current_parents=["12613010","1272-141-22-1"] #这个用df会出错

print(current_parents)

def fetch_sa_data():

# 执行数据库查询

query = f"""

SELECT *

FROM ct

WHERE `ct_ItemRelation` IN ({','.join([f"'{x}'" for x in current_parents])})

and `ct_mobileType` = "销售订单"

"""

chunk = pd.read_sql(query, engine)

return chunk

dfs_sa =fetch_sa_data()

print(dfs_sa)

返回：

['12613010', '1272-141-22-1']

[2258 rows x 28 columns]